package com.sto.stoapp.db.constant;

/**
 * 行政区域基本信息
 * 
 * @author Administrator
 * 
 */
public interface RegionInfoConstant extends StoBaseConstant {
	public static final String KEY = "key";
	public static final String CODE="code";
	public static final String LEVEL="level";
	public static final String NAME="name";
	public static final String PARENTCODE="parentCode";
	public static final String PARENTNAME="parentName";
	public static final String TYPE = "type";

	/**
	 *  行政区域基本信息表名
	 */
	public static final String REGION_INFO_TABLE = "region_info_table";

	/**
	 * 创建 行政区域基本信息表
	 */
	public static final String CREATE_REGION_INFO_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ REGION_INFO_TABLE
			+ "("
			+ "id TEXT PRIMARY KEY "
			+ ","
			+ KEY
			+ " text"
			+ ","
			+ CODE
			+ " text"
			+ ","
			+STATUS
			+" text "
			+","
			+ LEVEL
			+ " text"
			+ ","
			+ NAME
			+ " text"
			+ ","						
			+ PARENTCODE
			+ " text"
			+ ","	
			+ PARENTNAME
			+" text"
			+","		
			+ TYPE
			+ " text"
			+ ","		
			+ VERSION
			+ " text"
			+ ","
			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_TWO
			+ " char(50)"
			+ ","
			+ BACKUPS_THREE + " char(50)" + ")";
}
